package servlet;

import java.io.File;
import java.io.IOException;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.commons.fileupload.FileItem;
import org.apache.commons.fileupload.disk.DiskFileItemFactory;
import org.apache.commons.fileupload.servlet.ServletFileUpload;

import service.TaskInfoService;
import service.TasknoAutoService;
import util.ExcelTool;
import util.JsonTool;

@WebServlet("/TaskExcelServlet")
public class TaskExcelServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;

	// 上传文件存储目录
	private static final String UPLOAD_DIRECTORY = "uploadExcel";
	private static final String UPLOAD_IMG_DIRECTORY = "uploadImg";

	// 上传配置
	private static final int MEMORY_THRESHOLD = 1024 * 1024 * 20; // 20MB
	private static final int MAX_FILE_SIZE = 1024 * 1024 * 50; // 50MB
	private static final int MAX_REQUEST_SIZE = 1024 * 1024 * 50; // 50MB

	public TaskExcelServlet() {
		super();
	}

	protected void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		doPost(request, response);
	}

	protected void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		String message = "导入失败！";
		try {
			// 检测是否为多媒体上传
			if (ServletFileUpload.isMultipartContent(request)) {
				// 配置上传参数
				DiskFileItemFactory factory = new DiskFileItemFactory();
				// 设置内存临界值 - 超过后将产生临时文件并存储于临时目录中
				factory.setSizeThreshold(MEMORY_THRESHOLD);
				// 设置临时存储目录
				factory.setRepository(new File(System.getProperty("java.io.tmpdir")));
				ServletFileUpload upload = new ServletFileUpload(factory);
				// 设置最大文件上传值
				upload.setFileSizeMax(MAX_FILE_SIZE);
				// 设置最大请求值 (包含文件和表单数据)
				upload.setSizeMax(MAX_REQUEST_SIZE);
				// 中文处理
				upload.setHeaderEncoding("UTF-8");
				// 构造临时路径来存储上传的文件
				// 这个路径相对当前应用的目录
				String uploadPath = getServletContext().getRealPath("/") + File.separator + UPLOAD_DIRECTORY;
				// 如果目录不存在则创建
				File uploadDir = new File(uploadPath);
				if (!uploadDir.exists()) {
					uploadDir.mkdir();
				}
				String filePath = "";
				String taskno = new TasknoAutoService().getTaskno();
				try {
					// 解析请求的内容提取文件数据
					List<FileItem> formItems = upload.parseRequest(request);
	
					if (formItems != null && formItems.size() > 0) {
						// 迭代表单数据
						for (FileItem item : formItems) {
							// 处理不在表单中的字段
							if (!item.isFormField()) {
								String fileName = new File(item.getName()).getName();
								filePath = uploadPath + File.separator + taskno + "." + fileName.split("\\.")[1];
								File storeFile = new File(filePath);
								// 保存文件到硬盘
								item.write(storeFile);
							}
						}
					}
				} catch (Exception ex) {
					System.out.println(ex.getMessage());
				}
				List<List<String>> excel = ExcelTool.readExcel(filePath,
						getServletContext().getRealPath("/") + File.separator + UPLOAD_IMG_DIRECTORY + File.separator);
				TaskInfoService service = new TaskInfoService();
				for (List<String> row : excel) {
					taskno = new TasknoAutoService().getTaskno();
					String time = row.get(0);
					String username = row.get(1);
					String imgurl = row.get(2);
					String goodsname = row.get(3);
					String goodsNumber = row.get(4);
					String brand = row.get(5);
					String type = row.get(6);
					String color = row.get(7);
					String size = row.get(8);
					String price = row.get(9);
					String freight = row.get(10);
					String taskprice = row.get(11);
					String totalPrice = row.get(12);
					String payNo = row.get(13);
					service.addTask(taskno, username, brand, type, price, color, size, freight, 
							totalPrice, payNo, goodsname, imgurl, goodsNumber, time, taskprice);
				}
				message = "导入成功！";
			}
		}
		catch (Exception e) {
			e.printStackTrace();
			message += ",失败原因：" + e.getMessage();
		}
		Map<String, Object> map = new HashMap<>();
		map.put("message", message);
		response.getWriter().write(JsonTool.objectToJson(map));
	}
}
